USE DeltaFlex
GO
IF ( OBJECT_ID('dbo.sp_InsertarAlbara') IS NOT NULL ) 
   DROP PROCEDURE dbo.sp_InsertarAlbara
GO

CREATE PROCEDURE sp_InsertarAlbara
				@IDALBARA int,
				@IDORDRE int,
				@IDCLIENT int,
				@TOTAL decimal(8,4)
								
AS
BEGIN
	SET NOCOUNT ON

	INSERT INTO dbo.ALBARA
           (IDALBARA,
		   IDORDRE,
		   IDCLIENT,
		   DATA,
		   TOTAL)
     VALUES
           (@IDALBARA,
            @IDORDRE,
            @IDCLIENT,
			GETDATE(),
			@TOTAL)
	END
GO

